package com.sniff.atp.modules.test.smallTool;

/**
 * @ProjectName: sniff-atp
 * @Package: com.sniff.atp.modules.test.smallTool
 * @ClassName: ChangeDeliveryNo
 * @Description: java类作用描述
 * @Author: zss
 * @CreateDate: 2024/1/15 15:49
 * @UpdateDate: 2024/1/15 15:49
 * @Version: 1.0
 */
public class ChangeDeliveryNo {

    public static void main(String[] args) {
        String a = "GJFH2402281762718913707913216,GJFH2402281762718612502360064,GJFH2402281762718875594272768,GJFH2402281762817563821879296,GJFH2402291763084309103390720,GJFH2402261762041580477194240,GJFH2402281762718875552329728,GJFH2402281762817563490529280,GJFH2402281762718321950339072,GJFH2402281762718926500540416,GJFH2402291763084320780333056,GJFH2402261762041101700775936,GJFH2402261762041089005428736,GJFH2402261762041091164684288,GJFH2402261762041101521231872,GJFH2403011763366171285663745,GJFH2402281762718497872031744,GJFH2402281762817614195470336,GJFH2402261762039806470340608";
        String[] deliveryNo = a.split(",");

        String b = "09069779464,08023950060,09089996479,07016452117,09092260648,07038820641,07022110997,09053648965,08030111027,09078405112,08017924313,09060880877,09076409201,09070284302,08063441244,09051379111,08079451551,08065998197,09055526290";
        String[] expressNo = b.split(",");

        int lengthDelivery = deliveryNo.length;
        for(int i=0;i<lengthDelivery;i++){
            String sql = "";
            //修改电话
            sql = sql.concat("UPDATE `sniff_wms`.`wms_delivery_task_address` SET `mobile`='").concat(expressNo[i]);
            sql = sql.concat("' WHERE `delivery_task_code`='").concat(deliveryNo[i]);
            sql = sql.concat("' and `address_type` = 0;");

            //修改属性
//            sql = sql.concat("UPDATE `sniff_order`.`sniff_shop_product_sku` SET `product_properties_name`='");
//            sql = sql.concat(expressNo[i]).concat("' WHERE `shop_product_sku`='").concat(deliveryNo[i]);
//            sql = sql.concat("';");
            System.out.println(sql);
        }
    }



}
